/*
 Copyright (C) 2010 QDSS.org
 
 This program is free software: you can redistribute it and/or modify
 it under the terms of the GNU General Public License as published by
 the Free Software Foundation, either version 3 of the License, or
 any later version.

 This program is distributed in the hope that it will be useful,
 but WITHOUT ANY WARRANTY; without even the implied warranty of
 MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
 GNU General Public License for more details.
 
 You should have received a copy of the GNU General Public License
 along with this program.  If not, see <http://www.gnu.org/licenses/>.
 */
package org.qdss.commons.sql.builder;

import java.util.LinkedHashMap;
import java.util.Map;

import org.apache.commons.lang.ObjectUtils;
import org.qdss.commons.sql.SqlHelper;

/**
 * insert ...
 * 
 * @author <a href="mailto:zhaofang123@gmail.com">FANGFANG ZHAO</a>
 * @version $Id: InsertBuilder.java 78 2012-01-17 08:05:10Z zhaofang123@gmail.com $
 */
public class InsertBuilder extends BaseBuilder {

	final private Map<String, Object> columns = new LinkedHashMap<String, Object>();
	
	public InsertBuilder(String table) {
		super(table);
	}
	
	public InsertBuilder addColumn(String column) {
		return addColumn(column, ObjectUtils.NULL);
	}
	
	public InsertBuilder addColumn(String column, Object value) {
		columns.put(column, value);
		return this;
	}
	
	public String toSql() {
		StringBuffer sql = new StringBuffer("insert into ");
		sql.append(SqlHelper.wrapIdent(getTable().toLowerCase())).append(" (");
		
		StringBuffer values = new StringBuffer(") values (");
		
		for (Map.Entry<String, Object> e : columns.entrySet()) {
			sql.append(SqlHelper.wrapIdent(e.getKey())).append(", ");
			
			Object v = e.getValue();
			if (ObjectUtils.NULL == v)
				values.append("null");
			else if (Number.class.isAssignableFrom(v.getClass()))
				values.append(v);
			else
				values.append('\'').append(escapeSql(v)).append('\'');
			values.append(", ");
		}
		int len  = sql.length();
		sql.delete(len - 2, len);
		len  = values.length();
		values.delete(len - 2, len);
		
		sql.append(values).append(")");
		return sql.toString();
	}
}
